Model Table INVENTORY TRANSACTION HISTORY
This model dimension represents inventory transaction history and is based on
the IFS Cloud fact view FACT_INVENT_TRANS_HIST. All models that refers to
this dimension will have the attributes and hierarchies as described below.
Attributes
| Attribute |
Description (where applicable) |
| CONFIGURATION_ID | This number is automatically assigned to identify a specific part configuration specification which is a unique combination of characteristics and options that is used in conjunction with a Configurable part. |
| DIRECTION | The direction of the transaction. It describes whether
the quantity in stock is decreased (-), increased (+), or unaffected (0)
by the transaction. |
| INVENTORY TRANSACTION HISTORY ID | Displays the identification number of the inventory
transaction. |
| LOT_BATCH_NO | A lot or batch is a quantity of parts produced together that shares the same production specifications and costs. |
| ORDER_NO | Depending on the type of order, a reference to the origin is displayed. The order number is displayed for shop orders, work orders, customer orders, purchase orders, and material requisitions. |
| ORDER_TYPE | The type of order from which the transaction originated, e.g., a purchase order or shop order. |
| SOURCE | Identifies the source for the transaction |
| Waiv Dev Rej No | This is the quantity with a deviating W/D/R Number. |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| INVENTORY TRANSACTION HISTORY | FACT_INVENT_TRANS_HIST_TM | FACT_INVENT_TRANS_HIST_BI | FACT_INVENT_TRANS_HIST | Data Mart |